﻿CREATE TABLE [dbo].[SceneInfo] (
    [Id]       INT           IDENTITY (1, 1) NOT NULL,
    [CardType] INT           NULL,
    [CardNo]   NVARCHAR (50) NULL,
    [AddDt]    DATETIME      CONSTRAINT [DF__SceneInfo__AddDt__0E6E26BF] DEFAULT (getdate()) NULL,
    [ExpireDt] DATETIME      NULL,
    CONSTRAINT [PK_SceneInfo] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'主键', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SceneInfo', @level2type = N'COLUMN', @level2name = N'Id';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'卡类型', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SceneInfo', @level2type = N'COLUMN', @level2name = N'CardType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'卡号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SceneInfo', @level2type = N'COLUMN', @level2name = N'CardNo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'创建时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SceneInfo', @level2type = N'COLUMN', @level2name = N'AddDt';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'失效时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SceneInfo', @level2type = N'COLUMN', @level2name = N'ExpireDt';

